use StudentManagement1

---------------------------------COURSE-------------------------------------------
go
prcInsertCourse 'Dot Net'
go
prcInsertCourse 'Java'
go
prcInsertCourse 'C++'
go
prcInsertCourse 'Testing'
---------------------------------ROLE---------------------------------------------
go
prcInsertRole 'Admin'
go
prcInsertRole 'Coordinator'
go
prcInsertRole 'Trainer'
go
prcInsertRole 'Student'
---------------------------------LOGIN--------------------------------------------
go
prcInsertAccount 'hieunguyen1','R14',1
go
prcInsertAccount 'caothai1','R14',1
go
prcInsertAccount 'thanhnguyen1','R14',1
go
prcInsertAccount 'vutran1','R14',1
go
prcInsertAccount 'thongtran1','R14',1
go
prcInsertAccount 'tanhoang1','R14',1
go
prcInsertAccount 'phatnguyen1','R14',1
go
prcInsertAccount 'tuanle1','R13',1
go
prcInsertAccount 'trangnguyen1','R13',1
go
prcInsertAccount 'anhnguyen1','R12',1
go
prcInsertAccount 'AVan1','R11',1
---------------------------------PERSON-------------------------------------------
go
prcInsertPerson 'Nguyen Xuan Hieu','4/3/1986','20/B80','8627935','hieu.nguyen-k3@ttc.edu.vn' ,'NguyenXuanHieu.jpg','hieunguyen1'
go
prcInsertPerson 'Thai Thanh Cao','2/11/1986','40/230','9532011','cao.thai-k3@ttc.edu.vn' ,'','caothai1'
go
prcInsertPerson 'Nguyen Thi Phuong Thanh','9/4/1986','492/100','8932141','thanh.nguyen-k3@ttc.edu.vn' ,'','thanhnguyen1'
go
prcInsertPerson 'Tran Vu','12/1/1986','213 vo van tan','8798342','vu.tran-k3@ttc.edu.vn' ,'','vutran1'
go
prcInsertPerson 'Tran Gia Thong','2/23/1986','712 3 thang 2','8785421','thong.tran-k3@ttc.edu.vn' ,'','thongtran1'
go
prcInsertPerson 'Hoang Nhat Tan','11/15/1986','6 Nguyen Hue','8987452','tan.hoang-k3@ttc.edu.vn' ,'','tanhoang1'  
go
prcInsertPerson 'Nguyen Tan Phat','11/11/1986','21 Huynh Thuc Khang','8923451','phat.nguyen-k3@ttc.edu.vn' ,'','phatnguyen1'  
go
prcInsertPerson 'Le Tuan','2/12/1974','523 Le Van Sy','8798523','tuan.le-k3@ttc.edu.vn' ,'','tuanle1' 
go
prcInsertPerson 'Nguyen Thi Hong Trang','8/6/1982','4 Le Loi','9543623','trang.nguyen-k3@ttc.edu.vn' ,'','trangnguyen1' 
go
prcInsertPerson 'Nguyen Hoang Anh','1/12/1980','129 Huyng Thuc Khang','8546523','anh.nguyen-k3@ttc.edu.vn' ,'','anhnguyen1' 
go
prcInsertPerson 'Nguyen Van A','4/11/1978','53 Le Van Sy','9736512','A.Van-k3@ttc.edu.vn' ,'','avan1' 
---------------------------------CLASS--------------------------------------------
go
prcInsertClass 'DotNet1-k3' ,'C1001'
go
prcInsertClass 'DotNet2-k3' ,'C1001'
---------------------------------SUBJECT------------------------------------------
go
prcInsertSubject 'Introduce C#','C1001'
go
prcInsertSubject 'SQL Server','C1001'
---------------------------------SUBJECT DETAIL------------------------------------------
go
prcInsertSubjectDetail 'S1001','P10000008','CL1001'
go
prcInsertSubjectDetail 'S1002','P10000008','CL1001'
---------------------------------STUDENT------------------------------------------
go
prcInsertStudent 'P10000001','CL1001'
go
prcInsertStudent 'P10000002','CL1001'
go
prcInsertStudent 'P10000003','CL1001'
go
prcInsertStudent 'P10000004','CL1001'
go
prcInsertStudent 'P10000005','CL1001'
go
prcInsertStudent 'P10000006','CL1001'
go
prcInsertStudent 'P10000007','CL1001'
---------------------------------MARKS--------------------------------------------
go
prcInsertMarks 'P10000001',9
go
prcInsertMarks 'P10000002',9
go
prcInsertMarks 'P10000003',10
go
prcInsertMarks 'P10000004',9
go
prcInsertMarks 'P10000005',10
go
prcInsertMarks 'P10000006',7
go
prcInsertMarks 'P10000007',8

---------------------------------ROLLCALL-----------------------------------------
go
prcInsertRollcall 'P10000001','9/21/2008',1
go
prcInsertRollcall 'P10000002','9/21/2008',1
go
prcInsertRollcall 'P10000003','9/21/2008',0
go
prcInsertRollcall 'P10000004','9/21/2008',1
go
prcInsertRollcall 'P10000005','9/21/2008',1
go
prcInsertRollcall 'P10000006','9/21/2008',0
go
prcInsertRollcall 'P10000007','9/21/2008',1
go
prcInsertRollcall 'P10000001','9/23/2008',0
go
prcInsertRollcall 'P10000002','9/23/2008',1
go
prcInsertRollcall 'P10000003','9/23/2008',1
go
prcInsertRollcall 'P10000004','9/23/2008',1
go
prcInsertRollcall 'P10000005','9/23/2008',1
go
prcInsertRollcall 'P10000006','9/23/2008',1
go
prcInsertRollcall 'P10000007','9/23/2008',1
go
prcInsertRollcall 'P10000001','9/25/2008',0
go
prcInsertRollcall 'P10000002','9/25/2008',1
go
prcInsertRollcall 'P10000003','9/25/2008',0
go
prcInsertRollcall 'P10000004','9/25/2008',1
go
prcInsertRollcall 'P10000005','9/25/2008',1
go
prcInsertRollcall 'P10000006','9/25/2008',1
go
prcInsertRollcall 'P10000007','9/25/2008',1
go
prcInsertRollcall 'P10000001','9/26/2008',1
go
prcInsertRollcall 'P10000002','9/26/2008',1
go
prcInsertRollcall 'P10000003','9/26/2008',1
go
prcInsertRollcall 'P10000004','9/26/2008',1
go
prcInsertRollcall 'P10000005','9/26/2008',1
go
prcInsertRollcall 'P10000006','9/26/2008',0
go
prcInsertRollcall 'P10000007','9/26/2008',1
---------------------------------FEETYPE------------------------------------------
go
prcInsertFeeType 'Full',5000000
go
prcInsertFeeType 'Half of money',2500000
---------------------------------FEE----------------------------------------------
go
prcInsertFee 'P10000001','T11',0
go
prcInsertFee 'P10000002','T12',1
go
prcInsertFee 'P10000003','T11',1
go
prcInsertFee 'P10000004','T11',1
go
prcInsertFee 'P10000005','T11',0
go
prcInsertFee 'P10000006','T12',0
go
prcInsertFee 'P10000007','T11',1
go

--prcGetStudentsByClassID 'CL1001'
--prcGetAllStudents
--select * from Login
--select * from Person
--select * from SubjectDetail


